﻿<?xml version="1.0" encoding="utf-8" ?>
<settings defaultOrderBy='value'>
  <module>Pacm</module>
  <select>text,value, pid, remark</select>
  <from>
    (
    select Sbbylb_Lbbh as value,Sbbylb_Lbmc as text,Sbbylb_Sjbh as pid,Sbbylb_Remark as remark from b_Sbbylb
    union all
    select Sbbyxm_Xmbh as value,Sbbyxm_Xmmc as text,Sbbyxm_Lbbh as pid ,Sbbyxm_Tjyq as remark from b_Sbbyxm
    ) A
  </from>
  <where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' >
    <field name='text'       cp='like'  ></field>
    <field name='value'      cp='startwith'       ></field>
  </where>
</settings>